﻿CREATE DATABASE NLayersExampleDb;
GO

USE NLayersExampleDb;
GO

CREATE TABLE [dbo].[SampleCustomer](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Address] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_SampleCustomer] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


GO
INSERT INTO SampleCustomer (Name, Address) VALUES ('Joe', '1st Avenue');
INSERT INTO SampleCustomer (Name, Address) VALUES('Ram', '2nd Avenue');
INSERT INTO SampleCustomer (Name, Address) VALUES('Kite', '3rd Avenue');
INSERT INTO SampleCustomer (Name, Address) VALUES('Pike', '4th Avenue');